<%@page import="java.rmi.Remote"%>
<%@ page language="java" import="java.util.*,mySql.*" pageEncoding="utf-8"%>
<%@ page import="show_shop.*" %>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.Connection"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>  
  
    <title>order</title> 

	<link rel="stylesheet" type="text/css" href="../css/manage_order.css">
  

   

  </head>
  
 <body>
   <!-- header begin -->
   <div class="header">
	<div class="top-header">
	<div class="phone">
	<ul>
	<li class="tele"></li>
	<li class="telenum">
	<p>13739477470</p>
	</li>
	</ul>
	</div>
	
	<div class="logo">
	<h1><a href="http://localhost:8080/practise/jsp/manage_head.jsp">订单详情</a></h1>
	</div>
	
</div>
   </div>
   <!-- header end -->
   
   <!-- banner begin -->
   <div class="top_banner">
   <div class="navigation">
   <ul>
   <b>
   <li><a href="http://localhost:8080/practise/jsp/manage_order.jsp">订单详情</a></li>
   <li><a href="http://localhost:8080/practise/jsp/manage_publish.jsp">商品发布</a></li>
   <li><a href="http://localhost:8080/practise/jsp/manage_delete.jsp">商品删除</a></li>
   </b>
   </ul>
   </div>
 		
   </div>
   <!-- banner end -->
   
   <!-- body_content begin -->
   <div class="all"> 
   
   
   
   <%
  		response.setContentType("text/html;charset=gb2312");
  		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("UTF-8");
  			 String login_name="root";
			String login_password="2014121167";
			String driverClass="com.mysql.jdbc.Driver";
			String url="jdbc:mysql://localhost:3306/test";
			Connection con=null;
			PreparedStatement pst=null;
			ResultSet rs=null;
			int k=0;
					ArrayList<user_bean> user_message=new ArrayList<user_bean>();
   					
   				
   				
			DBConnection dbcon=new DBConnection(driverClass,url,login_password,login_name);
   			try
   			{
   					con=dbcon.getConnection();
   					pst=con.prepareStatement("select * from login");
   					rs=pst.executeQuery();
   			
   					while(rs.next())
   					{
   						user_bean user_mess=new user_bean();
   						user_mess.setUsername(rs.getString("name"));
   						user_mess.setPassword(rs.getString("password"));
						user_message.add(user_mess);					
   					}
   					session.setAttribute("user_message", user_message);				
   			}
   			catch (Exception e) {
				e.getStackTrace();
			
			}	
    %>
   
   
   
   <!-- one begin -->
   
   <%	
   			user_message=(ArrayList<user_bean>)session.getAttribute("user_message");	
   			if(k<user_message.size())
   			{  	
    %>
 	<div class="user">
 		<font size="+1">
 		<div class="font_i">
 			<div class="order_left">
 				用户名：<%=user_message.get(k).getUsername() %>
 			</div>
 			<div class="order_mid">
 				密码：<%=user_message.get(k).getPassword() %>
			</div> 			
 			<div class="order_right">
 				<a href="http://localhost:8080/practise/jsp/manage_date.jsp?id=<%=user_message.get(k).getUsername() %>&id_1=<%=user_message.get(k).getPassword() %>">订单详情</a>
 			</div>
 		</div>
 		</font>
 	</div>
 	<%
 	k++;}
 	 %>
		<!-- one end -->
		
		
		
		
		<!-- two begin -->
		 <%	
   			user_message=(ArrayList<user_bean>)session.getAttribute("user_message");	
   			if(k<user_message.size())
   			{  	
    %>
 	<div class="user">
 		<font size="+1">
 		<div class="font_i">
 			<div class="order_left">
 				用户名：<%=user_message.get(k).getUsername() %>
 			</div>
 			<div class="order_mid">
 				密码：<%=user_message.get(k).getPassword() %>
			</div> 			
 			<div class="order_right">
	<a href="http://localhost:8080/practise/jsp/manage_date.jsp?id=<%=user_message.get(k).getUsername() %>&id_1=<%=user_message.get(k).getPassword() %>">订单详情</a>
 			</div>
 		</div>
 		</font>
 	</div>
 	<%
 	k++;}
 	 %>
 		<!-- two end -->
 	
 		<!-- three begin -->
 	 	<%	
   			user_message=(ArrayList<user_bean>)session.getAttribute("user_message");	
   			if(k<user_message.size())
   			{  	
    %>
 	<div class="user">
 		<font size="+1">
 		<div class="font_i">
 			<div class="order_left">
 				用户名：<%=user_message.get(k).getUsername() %>
 			</div>
 			<div class="order_mid">
 				密码：<%=user_message.get(k).getPassword() %>
			</div> 			
 			<div class="order_right">
	<a href="http://localhost:8080/practise/jsp/manage_date.jsp?id=<%=user_message.get(k).getUsername() %>&id_1=<%=user_message.get(k).getPassword() %>">订单详情</a>
 			</div>
 		</div>
 		</font>
 	</div>
 	<%
 	k++;}
 	 %>
		<!-- three end -->
		
		
		
		<!-- four begin -->
		 <%	
   			user_message=(ArrayList<user_bean>)session.getAttribute("user_message");	
   			if(k<user_message.size())
   			{  	
    %>
 	<div class="user">
 		<font size="+1">
 		<div class="font_i">
 			<div class="order_left">
 				用户名：<%=user_message.get(k).getUsername() %>
 			</div>
 			<div class="order_mid">
 				密码：<%=user_message.get(k).getPassword() %>
			</div> 			
 			<div class="order_right">
 				<a href="http://localhost:8080/practise/jsp/manage_date.jsp?id=<%=user_message.get(k).getUsername() %>&id_1=<%=user_message.get(k).getPassword() %>">订单详情</a>
 			</div>
 		</div>
 		</font>
 	</div>
 	<%
 	k++;}
 	 %>
		<!-- four end -->
		
		
		
		<!-- five begin -->
		 <%	
   			user_message=(ArrayList<user_bean>)session.getAttribute("user_message");	
   			if(k<user_message.size())
   			{  	
    %>
 	<div class="user">
 		<font size="+1">
 		<div class="font_i">
 			<div class="order_left">
 				用户名：<%=user_message.get(k).getUsername() %>
 			</div>
 			<div class="order_mid">
 				密码：<%=user_message.get(k).getPassword() %>
			</div> 			
 			<div class="order_right">
 				<a href="http://localhost:8080/practise/jsp/manage_date.jsp?id=<%=user_message.get(k).getUsername() %>&id_1=<%=user_message.get(k).getPassword() %>">订单详情</a>
 			</div>
 		</div>
 		</font>
 	</div>
 	<%
 	k++;}
 	 %>
		<!-- five end -->
		
		
		
		<!-- six begin -->
		 <%	
   			user_message=(ArrayList<user_bean>)session.getAttribute("user_message");	
   			if(k<user_message.size())
   			{  	
    %>
 	<div class="user">
 		<font size="+1">
 		<div class="font_i">
 			<div class="order_left">
 				用户名：<%=user_message.get(k).getUsername() %>
 			</div>
 			<div class="order_mid">
 				密码：<%=user_message.get(k).getPassword() %>
			</div> 			
 			<div class="order_right">
 				<a href="http://localhost:8080/practise/jsp/manage_date.jsp?id=<%=user_message.get(k).getUsername() %>&id_1=<%=user_message.get(k).getPassword() %>">订单详情</a>
 			</div>
 		</div>
 		</font>
 	</div>
 	<%
 	k++;}
 	 %>
		<!-- six end -->
  </div>
   
   <!-- body_content end -->
   
   <!-- bottom begin -->
   <div class="bottom_show">
   <div class="picture_1">
 	<a href="#"></a>
   </div>
   <div class="picture_2">
 <a href="#"></a>
   </div>   
   <div class="picture_3">
  <a href="#"></a>
   </div>
    <div class="picture_4">
  <a href="#"></a>
   </div>
   
   
   </div>
      <div class="bottom_bar"></div>
   <div class="bottom_word">
	<p>航空港校区 | 四川省成都市西南航空港经济开发区学府路一段24号 | 右边610225 | 电话:028-85966502</p>
	<p>龙泉校区 | 成都市龙泉驿阳光城幸福路10号 | 邮编:610103 | 电话:028-84833333</p>
	<p>Copyringht 2003_2014 成都信息工程大学 建议使用IE8.0,1034*860以上浏览</p>
   </div>
   <!-- bottom end -->
   
  </body>
</html>
